﻿-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
USE [WarehouseManagement]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		AnhDQ
-- Create date: 3/22/2011
-- Description:	This stored procedure use to update an Employment Type record
-- =============================================
ALTER PROCEDURE [UpdateEmploymentType]
(
@EmploymentTypeID INT,
@EmploymentTypeCode VARCHAR(10),
@EmploymentType NVARCHAR(50), 
@BriefDescription NVARCHAR(500),
@FullDescription NVARCHAR(MAX)
)
AS
BEGIN
	
	UPDATE EmploymentType 
	SET
		EmploymentType = @EmploymentType,
		EmploymentTypeCode = @EmploymentTypeCode,
		[BriefDescription] = @BriefDescription,
		[FullDescription] = @FullDescription
	WHERE
		EmploymentTypeID = @EmploymentTypeID
				
END

/*
USE WarehouseManagement
GO

EXEC [UpdateEmploymentType] @EmploymentTypeID = 5,
	@EmploymentType = 'TestUpdate', 
	@Description = 'bbbbbbbbbbbbb'
*/

